Net Sales Analysis Report

The Net Sales Analysis report is a sales report that does not modify historical data when Prior Reversals and rebills are processed. Other sales reports, such as the Condensed Sales Analysis report, are modified by Prior Reversals and rebills. Since historical Net Sales Analysis reports are not modified by such transactions, the same data appears for the same report period, regardless of when it's generated.

The Net Sales Analysis report does not match other accounting reports.

The following non-retail Group Rx Statuses are included on the report:

A - Active Regular Dose D - Daily (for Monthly NH Only) I - Inactivate Regular
O - Active Non-Drug W - Active PRN Dose X - Active External

There are no sort options for this report. By default, the report is sorted alphabetically by Third Party name in ascending order.

Non-Financial Claims

Non-financial claims are not counted on the Net Sales Analysis report. This means prescriptions with a non-financial primary claim are counted under the first financial claim in the prescription's bill code. This ensures the prescription is counted under the appropriate Third Party when calculating prescription volume. The first financial claim can be a secondary or subsequent payor. Non-financial claims can be one of the following:

  • British Columbia PharmaCare claims that use a DE intervention code.

    If the prescription's bill code is PC/IA/CA and the DE intervention code is used for the PC claim, the PC claim becomes non-financial. The prescription is counted on the Net Sales Analysis report as an IA prescription instead of a PC prescription.

  • Manitoba Health claims that use a DU intervention code or the group ID DU in the patient's Third Party information.

    If the prescription's bill code is DU/VO/CA and the DU claim is non-financial, the prescription is counted on the Net Sales Analysis report as a VO prescription instead of a DU prescription.

  • Nova Scotia Prescription Monitoring Program (PMP) prescriptions that use a PM plan in the prescription's bill code.

    The prescription's bill code is PM/VO/CA. The PM claim is non-financial, so the prescription is counted on the Net Sales Analysis report as a VO prescription instead of a PM prescription.

  • A House Charge 100% deductible plan that is the primary Third Party in the prescription's bill code.

    If the prescription's bill code is HC/EP/CA and the patient has 100% deductible set for the HC plan, the HC claim is non-financial. The prescription is counted on the Net Sales Analysis report as an EP prescription instead of a HC prescription. If there are multiple House Charge 100% deductible plans in the bill code prior to the first financial plan, all the House Charge 100% deductible plans are considered non-financial. If the bill code is HC/HB/CA, the first financial plan is CA, so the prescription is counted as Cash.

The entered criteria appears at the top of the report.

  • Start Date and End Date - generates the report for prescriptions that were filled or reversed (for Prior Reversals) within the date range.

  • Group - generates the report for the specified group.

  • Custom Class - generates the report for the specified Custom Class.

  • Generics Only - generates the report for prescriptions filled for generic drugs. Use this option to obtain prescription volume and gross profit data for your generic business. When this option is selected, the indicator "Generic Drugs Only" appears at the top of the report.

    Generic products are flagged in Propel Rx according to the manufacturer code (i.e. Apotex is a generic manufacturer, so all Apotex drugs are flagged as generic).

  • Med Sync - generates the report for Med Sync prescriptions.

  • PrescribeIT® Only - generates the report for PrescribeIT® prescriptions.

  • Report Type

    • Summary - generates a net summary of prescription sales figures broken down by Third Party and plan. The report shows prescription sales for the report period as well as Prior Reversals and rebills.

    • Detailed - generates prescription sales, gross profit information, and prescription counts for each primary Third Party plan. Up to three sections can be generated for the report. If you would like to generate the report for only a specific section, deselect the unwanted sections. Each section is a minimum of one page. Therefore, the Detailed report is a minimum of three pages long when all sections are printed.

 

This section contains the following topics:

Net Sales Analysis Summary Report

Net Sales Analysis Detailed Report